Position Overview

Ultimate Staffing Services is seeking an experienced and detail-oriented Customer Service Representative to support our client in Scotts Valley, CA with a growing customer base in California. This role is ideal for someone with a strong customer-facing background combined with advanced Excel skills to manage complex order data, analyze trends, and support Sales/Customer Support activities. The successful candidate will have prior experience in creating sales forecasting dashboards and the ability to adapt to changes in a fast-paced company.

Responsibilities

• Serve as the primary point of contact for customer buyers, handling inquiries related to product availability, order status, lead times, and logistics.
• Process and track sales orders, RMAs, and delivery schedules using ERP system.
• Coordinate with internal departments (sales, demand planning, logistics, and quality) to resolve customer issues and ensure timely order fulfillment.
• Proactively communicate delays, changes, or updates to customers in a clear and professional manner.
• Maintain accurate customer records, pricing agreements, and shipment history.
• Identify and escalate urgent issues while recommending process improvements based on data analysis.
• Support forecasting and demand planning efforts through customer interaction and historical analysis.
• Use advanced Excel tools (pivot tables, VLOOKUP/XLOOKUP, Power Query, and macros) to manage customer data, forecast, generate reports, and analyze order trends.

Qualifications

• Bachelor's degree preferred.
• Minimum of 3 years of customer service experience, preferably in the semiconductor, electronics, or manufacturing industries.
• Advanced proficiency in Microsoft Excel (pivot tables, formulas, data analysis, charts, etc.).
• Strong understanding of order management systems (experience with customer portals SAP, Ariba Business Network & Syspro ERP system is a plus).
• Excellent communication and interpersonal skills.
• High attention to detail, with strong organizational and multitasking abilities.
• Data visualization skills (e.g., Power BI, Tableau) are a plus.

Required Work Hours

Monday to Friday, 1st Shift

Benefits

Competitive pay with a range of $32 to $35 per hour.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.